Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ReportingPeriodID (FK)(PK) | The unique system assigned identifier for a particular ReportingPeriod. | ID_PRD_RP | Identity | integer | ReportingPeriod(CA_PRD_RP) |
FuelingPointID (FK)(PK) | A unique identifier for the FuelingPoint at a particular retail store | ID_PNT_FUEL | Identity | integer | FuelingPoint(AS_PNT_FUEL) |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | FuelingPoint(AS_PNT_FUEL) |
PrepayFuelingTransactionCount | The number of prepay FuellingTransactions performed at the FuellingPoint during the ReportingPeriod | QU_TRN_FUEL_PSPY | QuantityTransactionCount | decimal(7,0) | |
PrepayFuelingTransactionTotalAmount | The total monetary amount of prepay FuellingTransactions performed at the FuellingPoint during the ReportingPeriod | MO_TRN_FUEL_PSPY | Money | decimal(16,5) | |
PrepayFuelingRefundCount | The number of prepay refund FuellingTransactions performed at the FuellingPoint during the ReportingPeriod | QU_RFD_FUEL_PSPY | QuantityTransactionCount | decimal(7,0) | |
PrepayFuelingRefundAmount | The total monetary value of prepay refund FuellingTransactions performed at the FuellingPoint during the ReportingPeriod | MO_RFD_FUEL_PSPY | Money | decimal(16,5) | |